2009-03-17 15:56:05.42 Server      Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) 
	Feb 26 2008 18:15:01 
	Copyright (c) 1988-2005 Microsoft Corporation
	Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2009-03-17 15:56:05.42 Server      Error: 17054, Severity: 16, State: 1.
2009-03-17 15:56:05.42 Server      The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full.
2009-03-17 15:56:05.42 Server      (c) 2005 Microsoft Corporation.
2009-03-17 15:56:05.42 Server      All rights reserved.
2009-03-17 15:56:05.42 Server      Server process ID is 768.
2009-03-17 15:56:05.42 Server      Authentication mode is WINDOWS-ONLY.
2009-03-17 15:56:05.42 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-03-17 15:56:05.42 Server      This instance of SQL Server last reported using a process ID of 432 at 2009-03-17 15:54:04 (local) 2009-03-17 20:54:04 (UTC). This is an informational message only; no user action is required.
2009-03-17 15:56:05.42 Server      Registry startup parameters:
2009-03-17 15:56:05.42 Server      	 -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-03-17 15:56:05.42 Server      	 -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-03-17 15:56:05.42 Server      	 -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-03-17 15:56:05.73 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-03-17 15:56:05.73 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2009-03-17 15:56:07.35 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2009-03-17 15:56:07.48 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-03-17 15:56:07.48 Server      The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
2009-03-17 15:56:07.90 Server      The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted.  If you would like distributed transaction functionality, please start this service.
2009-03-17 15:56:08.01 Server      Database mirroring has been enabled on this instance of SQL Server.
2009-03-17 15:56:08.03 spid5s      Starting up database 'master'.
2009-03-17 15:56:08.73 spid5s      7 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2009-03-17 15:56:08.79 spid5s      0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2009-03-17 15:56:08.79 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2009-03-17 15:56:08.98 spid5s      SQL Trace ID 1 was started by login "sa".
2009-03-17 15:56:09.06 spid5s      Starting up database 'mssqlsystemresource'.
2009-03-17 15:56:09.12 spid5s      The resource database build version is 9.00.3068. This is an informational message only. No user action is required.
2009-03-17 15:56:09.89 spid5s      Server name is 'DB07\SS2005'. This is an informational message only. No user action is required.
2009-03-17 15:56:09.89 spid9s      Starting up database 'model'.
2009-03-17 15:56:10.12 spid9s      Clearing tempdb database.
2009-03-17 15:56:10.18 Server      A self-generated certificate was successfully loaded for encryption.
2009-03-17 15:56:10.20 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SS2005 ].
2009-03-17 15:56:10.20 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SS2005\sql\query ].
2009-03-17 15:56:10.21 Server      Server is listening on [ 127.0.0.1 <ipv4> 1162].
2009-03-17 15:56:10.21 Server      Dedicated admin connection support was established for listening locally on port 1162.
2009-03-17 15:56:10.25 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2009-03-17 15:56:12.31 spid12s     Starting up database 'msdb'.
2009-03-17 15:56:12.31 spid13s     Starting up database 'AdventureWorksDW'.
2009-03-17 15:56:12.31 spid14s     Starting up database 'AdventureWorks'.
2009-03-17 15:56:12.31 spid15s     Starting up database 'distribution'.
2009-03-17 15:56:12.31 spid16s     Starting up database 'SQLNexus_WO140367_00'.
2009-03-17 15:56:12.31 spid17s     Starting up database 'SQLNexus_WO140367_01'.
2009-03-17 15:56:12.31 spid18s     Starting up database 'SQLNexus_WO140367_02'.
2009-03-17 15:56:12.31 spid19s     Starting up database 'sqlnexus'.
2009-03-17 15:56:14.64 spid13s     Starting up database 'SQLNexus_WO139030_14'.
2009-03-17 15:56:14.75 spid19s     Starting up database 'SQLNexus_WO139030_13'.
2009-03-17 15:56:15.06 spid5s      Recovery is writing a checkpoint in database 'distribution' (7). This is an informational message only. No user action is required.
2009-03-17 15:56:15.62 spid5s      Recovery is writing a checkpoint in database 'AdventureWorks' (6). This is an informational message only. No user action is required.
2009-03-17 15:56:15.73 spid15s     Starting up database 'SQLNexus_WO139030_15'.
2009-03-17 15:56:19.31 spid13s     Starting up database 'SQLNexus_WO139030_16'.
2009-03-17 15:56:20.31 spid19s     Starting up database 'SQLNexus_WO139030_17'.
2009-03-17 15:56:20.46 spid15s     Starting up database 'SQLNexus_WO139030_06'.
2009-03-17 15:56:20.51 spid17s     Starting up database 'SQLNexus_WO139030_07'.
2009-03-17 15:56:20.57 spid14s     Starting up database 'SQLNexus_WO139030_19'.
2009-03-17 15:56:20.81 spid5s      Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2009-03-17 15:56:21.45 spid12s     Starting up database 'SQLNexus_WO139030_20'.
2009-03-17 15:56:21.49 spid9s      Starting up database 'tempdb'.
2009-03-17 15:56:21.71 spid16s     Starting up database 'SQLNexus_WO140367_03'.
2009-03-17 15:56:23.50 spid13s     Starting up database 'SQLNexus_WO140367_04'.
2009-03-17 15:56:24.45 spid19s     Starting up database 'SQLNexus_WO140367_05'.
2009-03-17 15:56:24.76 spid14s     Starting up database 'SQLNexus_WO140367_06'.
2009-03-17 15:56:24.92 spid15s     Starting up database 'SQLNexus_WO140367_07'.
2009-03-17 15:56:25.76 spid12s     Starting up database 'WO143755_DiagDB_00'.
2009-03-17 15:56:25.90 spid22s     The Service Broker protocol transport is disabled or not configured.
2009-03-17 15:56:25.90 spid22s     The Database Mirroring protocol transport is disabled or not configured.
2009-03-17 15:56:26.48 spid22s     Service Broker manager has started.
2009-03-17 15:56:26.51 spid17s     Starting up database 'SQLNexus_WO140367_24'.
2009-03-17 15:56:27.58 spid12s     Analysis of database 'WO143755_DiagDB_00' (26) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2009-03-17 15:56:29.91 spid12s     Starting up database 'SQLNexus_WO140367_25'.
2009-03-17 15:56:30.38 spid18s     Starting up database 'ReportTesting'.
2009-03-17 15:56:35.95 spid5s      Recovery is complete. This is an informational message only. No user action is required.
2009-03-17 15:56:36.34 spid5s      Launched startup procedure 'sp_MSrepl_startup'.
2009-03-17 15:56:40.69 spid51      Using 'xpsqlbot.dll' version '2005.90.3042' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2009-03-17 15:56:41.22 spid51      Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2009-03-17 15:56:41.51 spid51      Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2009-03-17 16:00:11.54 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 16:00:11.54 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 16:15:01.61 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 16:15:01.61 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 16:30:01.65 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 16:30:01.65 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 16:45:01.62 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 16:45:01.62 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 17:00:01.68 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 17:00:01.68 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 17:15:01.67 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 17:15:01.67 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 17:30:01.69 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 17:30:01.69 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 17:45:01.68 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 17:45:01.68 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 18:00:01.77 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 18:00:01.77 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 18:15:01.66 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 18:15:01.66 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 18:30:01.72 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 18:30:01.72 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-17 18:45:01.71 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-17 18:45:01.71 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 00:00:14.57 spid13s     This instance of SQL Server has been using a process ID of 768 since 2009-03-17 15:56:36 (local) 2009-03-17 20:56:36 (UTC). This is an informational message only; no user action is required.
2009-03-18 08:00:01.69 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 08:00:01.69 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 08:15:01.63 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 08:15:01.63 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 08:30:01.69 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 08:30:01.69 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 08:45:01.82 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 08:45:01.82 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 09:00:02.07 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 09:00:02.07 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 09:15:01.70 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 09:15:01.70 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 09:30:02.03 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 09:30:02.03 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 09:45:02.10 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 09:45:02.10 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 10:00:02.32 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 10:00:02.32 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 10:15:02.56 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 10:15:02.56 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 10:30:01.93 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 10:30:01.93 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 10:45:01.94 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 10:45:01.94 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 11:00:03.41 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 11:00:03.41 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 11:15:01.96 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 11:15:01.96 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 11:30:01.95 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 11:30:01.95 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 11:45:01.97 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 11:45:01.97 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 12:00:02.07 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 12:00:02.07 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 12:15:02.06 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 12:15:02.06 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 12:30:02.22 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 12:30:02.22 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 12:45:02.11 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 12:45:02.11 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 13:00:02.52 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 13:00:02.52 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 13:15:02.14 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 13:15:02.14 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 13:30:01.42 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 13:30:01.42 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 13:45:01.42 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 13:45:01.42 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 14:00:01.60 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 14:00:01.60 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 14:15:01.81 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 14:15:01.81 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 14:17:41.57 spid60      DBCC TRACEON 3605, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 14:17:41.57 spid60      DBCC TRACEON 1204, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 14:21:55.38 spid4s      Deadlock encountered .... Printing deadlock information
2009-03-18 14:21:55.38 spid4s      Wait-for graph
2009-03-18 14:21:55.38 spid4s      
2009-03-18 14:21:55.38 spid4s      Node:1

2009-03-18 14:21:55.38 spid4s      KEY: 6:72057594044678144 (9a007a9f000e) CleanCnt:3 Mode:X Flags: 0x0
2009-03-18 14:21:55.38 spid4s       Grant List 1:
2009-03-18 14:21:55.38 spid4s         Owner:0x03D0D600 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:58 ECID:0 XactLockInfo: 0x133524FC
2009-03-18 14:21:55.38 spid4s         SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 14:21:55.38 spid4s         Input Buf: Language Event: UPDATE [Purchasing].[PurchaseOrderDetail]
SET [OrderQty] = [OrderQty] - 200
WHERE
(
    ([ProductID] = 922)
    AND
    ([PurchaseOrderID] = 499)
);

2009-03-18 14:21:55.38 spid4s       Requested By: 
2009-03-18 14:21:55.38 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x13353038 Mode: X SPID:59 BatchID:0 ECID:0 TaskProxy:(0x13430378) Value:0x3d0cf80 Cost:(0/2284)
2009-03-18 14:21:55.38 spid4s      
2009-03-18 14:21:55.38 spid4s      Node:2

2009-03-18 14:21:55.38 spid4s      KEY: 6:72057594045661184 (4a014ca79d1c) CleanCnt:2 Mode:X Flags: 0x0
2009-03-18 14:21:55.38 spid4s       Grant List 1:
2009-03-18 14:21:55.38 spid4s         Owner:0x03D0C820 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:59 ECID:0 XactLockInfo: 0x1335305C
2009-03-18 14:21:55.38 spid4s         SPID: 59 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 14:21:55.38 spid4s         Input Buf: Language Event: UPDATE [Production].[Product]
SET [ListPrice] = [ListPrice] * 0.9
WHERE ([ProductID] = 922);

2009-03-18 14:21:55.38 spid4s       Requested By: 
2009-03-18 14:21:55.38 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x133524D8 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x129F6378) Value:0x3d0c740 Cost:(0/356)
2009-03-18 14:21:55.38 spid4s      
2009-03-18 14:21:55.38 spid4s      Victim Resource Owner:
2009-03-18 14:21:55.38 spid4s       ResType:LockOwner Stype:'OR'Xdes:0x133524D8 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x129F6378) Value:0x3d0c740 Cost:(0/356)
2009-03-18 14:25:04.42 spid64      SQL Trace ID 2 was started by login "DRTN\tbarkhouse".
2009-03-18 14:26:01.55 spid4s      Deadlock encountered .... Printing deadlock information
2009-03-18 14:26:01.55 spid4s      Wait-for graph
2009-03-18 14:26:01.56 spid4s      
2009-03-18 14:26:01.56 spid4s      Node:1

2009-03-18 14:26:01.56 spid4s      KEY: 6:72057594044678144 (9a007a9f000e) CleanCnt:3 Mode:X Flags: 0x0
2009-03-18 14:26:01.56 spid4s       Grant List 1:
2009-03-18 14:26:01.56 spid4s         Owner:0x03D0C360 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:58 ECID:0 XactLockInfo: 0x141EB20C
2009-03-18 14:26:01.56 spid4s         SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 14:26:01.56 spid4s         Input Buf: Language Event: UPDATE [Purchasing].[PurchaseOrderDetail]
SET [OrderQty] = [OrderQty] - 200
WHERE
(
    ([ProductID] = 922)
    AND
    ([PurchaseOrderID] = 499)
);

2009-03-18 14:26:01.56 spid4s       Requested By: 
2009-03-18 14:26:01.56 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x141EA8C8 Mode: X SPID:59 BatchID:0 ECID:0 TaskProxy:(0x13430378) Value:0x3d0c840 Cost:(0/2284)
2009-03-18 14:26:01.56 spid4s      
2009-03-18 14:26:01.56 spid4s      Node:2

2009-03-18 14:26:01.56 spid4s      KEY: 6:72057594045661184 (4a014ca79d1c) CleanCnt:2 Mode:X Flags: 0x0
2009-03-18 14:26:01.56 spid4s       Grant List 1:
2009-03-18 14:26:01.56 spid4s         Owner:0x03D0CA40 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:59 ECID:0 XactLockInfo: 0x141EA8EC
2009-03-18 14:26:01.56 spid4s         SPID: 59 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 14:26:01.56 spid4s         Input Buf: Language Event: UPDATE [Production].[Product]
SET [ListPrice] = [ListPrice] * 0.9
WHERE ([ProductID] = 922);

2009-03-18 14:26:01.56 spid4s       Requested By: 
2009-03-18 14:26:01.56 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x141EB1E8 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x129F6378) Value:0x3d0cc00 Cost:(0/356)
2009-03-18 14:26:01.56 spid4s      
2009-03-18 14:26:01.56 spid4s      Victim Resource Owner:
2009-03-18 14:26:01.56 spid4s       ResType:LockOwner Stype:'OR'Xdes:0x141EB1E8 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x129F6378) Value:0x3d0cc00 Cost:(0/356)
2009-03-18 14:26:43.41 spid65      SQL Trace stopped. Trace ID = '2'. Login Name = 'DRTN\tbarkhouse'.
2009-03-18 14:30:01.75 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 14:30:01.75 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 14:31:16.75 spid64      SQL Trace ID 2 was started by login "DRTN\tbarkhouse".
2009-03-18 14:31:39.29 spid60      DBCC TRACEON 3605, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 14:31:39.29 spid60      DBCC TRACEON 1222, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 14:31:54.79 spid60      DBCC TRACEOFF 1222, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 14:32:52.21 spid4s      Deadlock encountered .... Printing deadlock information
2009-03-18 14:32:52.21 spid4s      Wait-for graph
2009-03-18 14:32:52.21 spid4s      
2009-03-18 14:32:52.21 spid4s      Node:1

2009-03-18 14:32:52.21 spid4s      KEY: 6:72057594044678144 (9a007a9f000e) CleanCnt:3 Mode:X Flags: 0x0
2009-03-18 14:32:52.21 spid4s       Grant List 1:
2009-03-18 14:32:52.21 spid4s         Owner:0x03D0CC60 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:58 ECID:0 XactLockInfo: 0x134D8274
2009-03-18 14:32:52.21 spid4s         SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 14:32:52.21 spid4s         Input Buf: Language Event: UPDATE [Purchasing].[PurchaseOrderDetail]
SET [OrderQty] = [OrderQty] - 200
WHERE
(
    ([ProductID] = 922)
    AND
    ([PurchaseOrderID] = 499)
);

2009-03-18 14:32:52.21 spid4s       Requested By: 
2009-03-18 14:32:52.21 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x13352250 Mode: X SPID:59 BatchID:0 ECID:0 TaskProxy:(0x1342E378) Value:0x3d0c640 Cost:(0/2284)
2009-03-18 14:32:52.21 spid4s      
2009-03-18 14:32:52.21 spid4s      Node:2

2009-03-18 14:32:52.21 spid4s      KEY: 6:72057594045661184 (4a014ca79d1c) CleanCnt:2 Mode:X Flags: 0x0
2009-03-18 14:32:52.21 spid4s       Grant List 1:
2009-03-18 14:32:52.21 spid4s         Owner:0x03D0C780 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:59 ECID:0 XactLockInfo: 0x13352274
2009-03-18 14:32:52.21 spid4s         SPID: 59 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 14:32:52.21 spid4s         Input Buf: Language Event: UPDATE [Production].[Product]
SET [ListPrice] = [ListPrice] * 0.9
WHERE ([ProductID] = 922);

2009-03-18 14:32:52.21 spid4s       Requested By: 
2009-03-18 14:32:52.21 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x134D8250 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x13580378) Value:0x3d0c920 Cost:(0/356)
2009-03-18 14:32:52.21 spid4s      
2009-03-18 14:32:52.21 spid4s      Victim Resource Owner:
2009-03-18 14:32:52.21 spid4s       ResType:LockOwner Stype:'OR'Xdes:0x134D8250 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x13580378) Value:0x3d0c920 Cost:(0/356)
2009-03-18 14:45:01.63 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 14:45:01.63 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 15:00:01.88 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 15:00:01.88 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 15:15:01.73 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 15:15:01.73 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 15:30:01.81 Backup      Error: 3041, Severity: 16, State: 1.
2009-03-18 15:30:01.81 Backup      BACKUP failed to complete the command BACKUP LOG ReportTesting. Check the backup application log for detailed messages.
2009-03-18 15:39:45.41 spid60      SQL Trace stopped. Trace ID = '2'. Login Name = 'DRTN\tbarkhouse'.
2009-03-18 15:41:15.83 spid60      DBCC TRACEON 3605, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 15:41:15.83 spid60      DBCC TRACEON 1222, server process ID (SPID) 60. This is an informational message only; no user action is required.
2009-03-18 15:42:05.54 spid4s      Deadlock encountered .... Printing deadlock information
2009-03-18 15:42:05.54 spid4s      Wait-for graph
2009-03-18 15:42:05.54 spid4s      
2009-03-18 15:42:05.54 spid4s      Node:1

2009-03-18 15:42:05.54 spid4s      KEY: 6:72057594044678144 (9a007a9f000e) CleanCnt:3 Mode:X Flags: 0x0
2009-03-18 15:42:05.54 spid4s       Grant List 1:
2009-03-18 15:42:05.54 spid4s         Owner:0x03D0B0A0 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:58 ECID:0 XactLockInfo: 0x13352B94
2009-03-18 15:42:05.54 spid4s         SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 15:42:05.54 spid4s         Input Buf: Language Event: UPDATE [Purchasing].[PurchaseOrderDetail]
SET [OrderQty] = [OrderQty] - 200
WHERE
(
    ([ProductID] = 922)
    AND
    ([PurchaseOrderID] = 499)
);

2009-03-18 15:42:05.54 spid4s       Requested By: 
2009-03-18 15:42:05.54 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x13352250 Mode: X SPID:59 BatchID:0 ECID:0 TaskProxy:(0x1342E378) Value:0x3d0c840 Cost:(0/2284)
2009-03-18 15:42:05.54 spid4s      
2009-03-18 15:42:05.54 spid4s      Node:2

2009-03-18 15:42:05.54 spid4s      KEY: 6:72057594045661184 (4a014ca79d1c) CleanCnt:2 Mode:X Flags: 0x0
2009-03-18 15:42:05.54 spid4s       Grant List 1:
2009-03-18 15:42:05.54 spid4s         Owner:0x03D0D020 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:59 ECID:0 XactLockInfo: 0x13352274
2009-03-18 15:42:05.54 spid4s         SPID: 59 ECID: 0 Statement Type: UPDATE Line #: 1
2009-03-18 15:42:05.54 spid4s         Input Buf: Language Event: UPDATE [Production].[Product]
SET [ListPrice] = [ListPrice] * 0.9
WHERE ([ProductID] = 922);

2009-03-18 15:42:05.54 spid4s       Requested By: 
2009-03-18 15:42:05.54 spid4s         ResType:LockOwner Stype:'OR'Xdes:0x13352B70 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x13580378) Value:0x3d0ca20 Cost:(0/356)
2009-03-18 15:42:05.54 spid4s      
2009-03-18 15:42:05.54 spid4s      Victim Resource Owner:
2009-03-18 15:42:05.54 spid4s       ResType:LockOwner Stype:'OR'Xdes:0x13352B70 Mode: U SPID:58 BatchID:0 ECID:0 TaskProxy:(0x13580378) Value:0x3d0ca20 Cost:(0/356)
2009-03-18 15:42:05.54 spid13s     deadlock-list
2009-03-18 15:42:05.54 spid13s      deadlock victim=process988c58
2009-03-18 15:42:05.54 spid13s       process-list
2009-03-18 15:42:05.54 spid13s        process id=process988c58 taskpriority=0 logused=356 waitresource=KEY: 6:72057594045661184 (4a014ca79d1c) waittime=4640 ownerId=1107065 transactionname=user_transaction lasttranstarted=2009-03-18T15:41:47.713 XDES=0x13352b70 lockMode=U schedulerid=2 kpid=8988 status=suspended spid=58 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-03-18T15:42:00.900 lastbatchcompleted=2009-03-18T15:41:47.713 clientapp=Microsoft SQL Server Management Studio - Query hostname=DB07 hostpid=18424 loginname=DRTN\tbarkhouse isolationlevel=read committed (2) xactid=1107065 currentdb=6 lockTimeout=4294967295 clientoption1=671090784 clientoption2=390200
2009-03-18 15:42:05.54 spid13s         executionStack
2009-03-18 15:42:05.54 spid13s          frame procname=adhoc line=1 sqlhandle=0x020000004fbb092c29dceca676884294df83a6c4d191eec8
2009-03-18 15:42:05.54 spid13s     (@1 int,@2 smallint,@3 smallint)UPDATE [Purchasing].[PurchaseOrderDetail] set [OrderQty] = [OrderQty]-@1  WHERE [ProductID]=@2 AND [PurchaseOrderID]=@3     
2009-03-18 15:42:05.54 spid13s          frame procname=adhoc line=1 sqlhandle=0x02000000ec8dc332200a10a5c07fcee6a82c01cad9b177c0
2009-03-18 15:42:05.54 spid13s     UPDATE [Purchasing].[PurchaseOrderDetail]
2009-03-18 15:42:05.54 spid13s     SET [OrderQty] = [OrderQty] - 200
2009-03-18 15:42:05.54 spid13s     WHERE
2009-03-18 15:42:05.54 spid13s     (
2009-03-18 15:42:05.54 spid13s         ([ProductID] = 922)
2009-03-18 15:42:05.54 spid13s         AND
2009-03-18 15:42:05.54 spid13s         ([PurchaseOrderID] = 499)
2009-03-18 15:42:05.54 spid13s     );     
2009-03-18 15:42:05.54 spid13s         inputbuf
2009-03-18 15:42:05.54 spid13s     UPDATE [Purchasing].[PurchaseOrderDetail]
2009-03-18 15:42:05.54 spid13s     SET [OrderQty] = [OrderQty] - 200
2009-03-18 15:42:05.54 spid13s     WHERE
2009-03-18 15:42:05.54 spid13s     (
2009-03-18 15:42:05.54 spid13s         ([ProductID] = 922)
2009-03-18 15:42:05.54 spid13s         AND
2009-03-18 15:42:05.54 spid13s         ([PurchaseOrderID] = 499)
2009-03-18 15:42:05.54 spid13s     );
2009-03-18 15:42:05.54 spid13s        process id=process988e38 taskpriority=0 logused=2284 waitresource=KEY: 6:72057594044678144 (9a007a9f000e) waittime=13687 ownerId=1107057 transactionname=user_transaction lasttranstarted=2009-03-18T15:41:45.680 XDES=0x13352250 lockMode=X schedulerid=2 kpid=18352 status=suspended spid=59 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-03-18T15:41:51.853 lastbatchcompleted=2009-03-18T15:41:45.680 lastattention=2009-03-18T15:41:32.337 clientapp=Microsoft SQL Server Management Studio - Query hostname=DB07 hostpid=18424 loginname=DRTN\tbarkhouse isolationlevel=read committed (2) xactid=1107057 currentdb=6 lockTimeout=4294967295 clientoption1=671090784 clientoption2=390200
2009-03-18 15:42:05.54 spid13s         executionStack
2009-03-18 15:42:05.54 spid13s          frame procname=adhoc line=1 stmtstart=58 sqlhandle=0x0200000040756627d0581021091c2bcb38bd70b4892954f4
2009-03-18 15:42:05.54 spid13s     UPDATE [Production].[Product] set [ListPrice] = [ListPrice]*@1  WHERE [ProductID]=@2     
2009-03-18 15:42:05.54 spid13s          frame procname=adhoc line=1 sqlhandle=0x02000000921a2730641bb27fbc088877459f0b8e9692825b
2009-03-18 15:42:05.54 spid13s     UPDATE [Production].[Product]
2009-03-18 15:42:05.54 spid13s     SET [ListPrice] = [ListPrice] * 0.9
2009-03-18 15:42:05.54 spid13s     WHERE ([ProductID] = 922);     
2009-03-18 15:42:05.54 spid13s         inputbuf
2009-03-18 15:42:05.54 spid13s     UPDATE [Production].[Product]
2009-03-18 15:42:05.54 spid13s     SET [ListPrice] = [ListPrice] * 0.9
2009-03-18 15:42:05.54 spid13s     WHERE ([ProductID] = 922);
2009-03-18 15:42:05.54 spid13s       resource-list
2009-03-18 15:42:05.54 spid13s        keylock hobtid=72057594044678144 dbid=6 objectname=AdventureWorks.Production.Product indexname=PK_Product_ProductID id=lock3ca5280 mode=X associatedObjectId=72057594044678144
2009-03-18 15:42:05.55 spid13s         owner-list
2009-03-18 15:42:05.55 spid13s          owner id=process988c58 mode=X
2009-03-18 15:42:05.55 spid13s         waiter-list
2009-03-18 15:42:05.55 spid13s          waiter id=process988e38 mode=X requestType=wait
2009-03-18 15:42:05.55 spid13s        keylock hobtid=72057594045661184 dbid=6 objectname=AdventureWorks.Purchasing.PurchaseOrderDetail indexname=PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID id=lock3ca6200 mode=X associatedObjectId=72057594045661184
2009-03-18 15:42:05.55 spid13s         owner-list
2009-03-18 15:42:05.55 spid13s          owner id=process988e38 mode=X
2009-03-18 15:42:05.55 spid13s         waiter-list
2009-03-18 15:42:05.55 spid13s          waiter id=process988c58 mode=U requestType=wait
